Test Yourself

 

1. Which of the following is true about Macros?

(Select all correct answers)
a. Macros record actions as you complete a task
b. The user must specify the start and stop to a macro recording
c. Macros will record mistakes
Tip: Advanced Excel, page 248, 252

2. Which Ribbon has commands for Macros?
a. Home
b. Review
c. Developer
d. Tools
Tip: Advanced Excel, 250

3. Microsoft Office allows users to do what with Macros?

(Select all correct answers)
a. Add macros to the Ribbon
b. Create a new group for a user-created macro.
c. Use a custom icon for a user-created macro
Tip: Advanced Excel, page 263, 264, 265

4. Which of the following is true about Macro Security?
a. Macros are disabled by default because they are a security risk
b. Macros can be permanently enabled in a spreadsheet
c. Macros can be temporarily enabled in a spreadsheet for only the current session
d. The settings for Macros are found in the Trust Center
Tip: Advanced Excel, page 271, 272, 274

5. Which of the following can be customized in Excel? (Select all correct answers)
a. Ribbons
b. Quick Access Toolbar
c. Document Properties
Tip: Advanced Excel, page 268